CREATE DATABASE SchoolDB;
GO
USE SchoolDB;
GO
CREATE TABLE Students (
RollNo INT PRIMARY KEY, Name VARCHAR(100), CourseName VARCHAR(100)
);
GO
-- Insert sample records
INSERT INTO Students (RollNo, Name, CourseName) VALUES (1, 'John Doe', 'Mathematics');
INSERT INTO Students (RollNo, Name, CourseName) VALUES (2, 'Jane Smith', 'Science');
INSERT INTO Students (RollNo, Name, CourseName) VALUES (3, 'Sam Brown', 'History');